Now there's kind of a flipside to trace precedents.
I could also trace the dependence of a formula.
Take a look.
So first I'm going to get rid of these arrows that are showing me the precedents of these various formulas
.
So remove some Then I'll go back to formulas in the formula auditing and I'm going to remove the arrows
just one button press and all those arrows are going on.
Now let's try this.
I mean clicking on one of these weekly values and let's grab this sixty nine hundred years. This is
cell number C6.
Now I want to know what other cells depend on that cell right there.
And the dependence of cells C6 so that self-selected back the formulas in the formula auditing.
And I'm going to trace the dependence.
Give that a click and now it's drawing these arrows.
I've got the total down here for week two.
I've got the row total for k done and I've got the no bonus.
That also relies on it as well.
The cell is 6 so I'm now tracing what cells depend on that's like this cell of C6.
Let's try another one here uncock into this 34000 the monthly goal the cell to back the formulas in
the formula auditing and I'll trace the dependence.
Now the monthly goal you might remember way back when we were talking about the if statement or the
IF function.
Each of these was the goal Matt.
Yes No No Yes.
Yes.
These all rely right on that monthly goal they all use it in some way.
So these cells are dependent on that 34000.
So simple button press and just like tracing the pendants you can remove the arrows just as quickly
and go back up to remove arrows give them a click and I'll remove all of those arrows.
It's a super slick tool especially when you're in a scenario where you're you're inheriting work from
somebody else and before you get in there start modifying the document.
We can really start to audit it.
Take a look at what sells out formulas and what sells are dependent upon other cells that rely on other
cells whatever it might be before you really start to modify the document tweak it potentially breaking
something.
We can take a look at tracing the dependence and tracing the precedents of formulas.
So once again try this out get a feel for working with traist dependence cook in a cell.
Maybe one of the weekly values are a monthly goal or perhaps one of your old workbooks give that trace
depends button click and see what formulas rely on that sells value.